set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
/* *******************************************************************
** DATE :
** Writer :
** Memo :
******************************************************************** */
CREATE PROCEDURE [dbo].[TSP_EventComment_Remove]
(
	@IsTransaction	tinyint			= 0
,	@ErrorCode		int				= 0		OUTPUT
,	@ErrorMessage	nvarchar( 1000 )= ''	OUTPUT

,	@n4EventCommentSN	int	
)
as
Set NOCOUNT ON

-- Frk Default Value
DECLARE @FrkDateNow DateTime
DECLARE @FrkRowCount int
DECLARE @FrkTranCount int
DECLARE @FrkErrorCode int
DECLARE @FrkErrorMessage nvarchar( 1000 )
Set @FrkDateNow = GetDate()
set @FrkTranCount = @@TRANCOUNT
-- Frk Check


If ( @IsTransaction = 0 )
Begin
	If ( @FrkTranCount < 1 )
	Begin
		Set @FrkErrorCode = -1
		Set @FrkErrorMessage = 'Transaction.'
		goto ERROR
	End
	Else If ( @FrkTranCount > 1 )
	Begin
		Set @FrkErrorCode = -2
		Set @FrkErrorMessage = 'Transaction.'
		goto ERROR
	End
End
Else
Begin
	If ( @FrkTranCount <> 0 )
	Begin
		Set @FrkErrorCode = -3
		Set @FrkErrorMessage = 'Transaction.'
		goto ERROR
	End
	Begin Tran
End

-- Implementation
DECLARE	@n4UserNo	INT
DECLARE	@n4EventSN	INT
DECLARE @n4Count	INT
SELECT
	@n4UserNo = n4UserNo
,	@n4EventSN = n4EventSN
FROM
	TB_EventComment with ( nolock )
WHERE
	n4EventCommentSN = @n4EventCommentSN

IF ( @n4EventSN <> 0 )
BEGIN
	UPDATE
		TB_EventComment
	SET
		IsRemove = 1
	WHERE
		n4EventCommentSN = @n4EventCommentSN
	SELECT
		@FrkErrorCode = @@ERROR
	,	@FrkRowCount = @@RowCount

	UPDATE	
		TB_EventCommentWriter
	SET
		@n4Count = n4Count = n4Count - 1
	WHERE
		n4EventSN = @n4EventSN
	AND	n4UserNo = @n4UserNo
	
	UPDATE
		TB_Event
	SET
		n4TotalCommentCount = n4TotalCommentCount - 1
	,	n4UniqueUserCount = n4UniqueUserCount - CASE WHEN @n4Count = 0 THEN 1 ELSE 0 END
	WHERE
		n4EventSN = @n4EventSN
END


-- Frk Error Check
SELECT
	@FrkErrorCode = @@ERROR
,	@FrkRowCount = @@RowCount

-- End

COMPLETE:
	If ( @IsTransaction <> 0 )
	Begin
		If ( @@TRANCOUNT = 1 )
		Begin
			Commit Tran
		End
	End
	SET @ErrorCode = 0
	SET @ErrorMessage = ''
	return 0
ERROR:
	If ( @IsTransaction <> 0 )
	Begin
		If ( @@TRANCOUNT = 1 )
		Begin
			Rollback Tran
		End
	End
	SET @ErrorCode = @FrkErrorCode
	SET @ErrorMessage = @FrkErrorMessage
	return @FrkErrorCode
